How to apply WHILE loop with simple examples in SQL server?

Question

Amrita Bhattacharjee · Accepted Answer

DECLARE @count INT;
SET @count = 1;
 and and  
WHILE @countandlt;= 20
BEGIN
 and  PRINT @count
 and  SET @count = @count + 1;
END;
Above is an example of using WHILE loop in SQL whereas the loop will print the numbers 1 to 20. DECLARE statement here initializes the counter variable. PRINT statement is used to give the output value of the counter which is based on the condition that if the condition is true then only the PRINT statement will give the counter variable value as output. SET statement is used for incrementing the value of counter variable by 1 and the above loop will continue until the value of counter variable meets equal or less than 20 or else until the condition becomes false to end the whole process.

forum

How to apply WHILE loop with simple examples in SQL server?

Ravi Vishwakarma

Can you answer this question?

1 Answers

Liked By